The Lifecycle Planning Worksheet is intended to make it easier for you to get a simple overview of the item stock level and to ease the pricing and offer process.
You can filter on a worksheet and possibly on a store. On the right-hand side of the worksheet there are FactBoxes and Value Charts with information related to the worksheet lines.
Discount & Markdown FactBox
If you choose to add an item to a discount offer by entering a value in the field New Discount %, the Discount Value in the Discount & Markdown FactBox displays the total value of such discounts before the discount lines are created. If you change the item’s price by entering a value in the New Price field, the Markdown Value in the FactBox displays the total value of the price changes suggested in the worksheet before the new sales price lines are created.
After adding the items to a discount offer, the New Discount % values are set to zero, hence the Discount Value in the FactBox is also set to zero. After adding a new sales price to an item the Markdown Value is set to zero. These values are explained in Setting New Discount % and Setting New Prices in the Worksheet Line Values topic.
Item Lifecycle FactBox
The Item Lifecycle Factbox shows information on the item in the selected line.
The Days of Life Remaining represents the number of days left of the season associated with the worksheet selected. Days for Sale displays the number of days within the season period that the item has been on sale. Other fields in this Factbox are the same as in the worksheet lines and are discussed elsewhere.
Charts
The Inventory, and Item Sales Chart display, for the selected item line in the worksheet, the item’s inventory and sales quantities over a period of time starting with one of these:
- The item’s Lifecycle Starting Date, if selected on the
- The selected Season’s Starting Date, if selected and the property in case 1 is not set.
- The beginning of 12 weeks from TODAY, if the properties in case 1 and 2 are not set.
In the Inventory Chart the inventory values are calculated over the time period from the beginning as described and up to today.
The item sales that have not been included in a posted statement are not included in the chart quantities.
There are three options for the Period Length: Day, Week and Month. The default value for the chart is Week. The chart columns represent the inventory value over the selected period. The X-axis value represents the beginning of the period. That is, as shown in the image, the period selected is Week, then the column for 24.11.14 represents the cumulative change in inventory over the week 24.11.14 to 30.11.14.
Note: The first column in the image does not represent a whole week. This is because the season in consideration does not start on a Monday. It starts on Wednesday 01.10.14, hence the first column represents the week part from the beginning of the season until the beginning of the first whole week of the season.
Pressing Refresh on the chart results in displaying the values with regard to the default Period Length Week.
In the Item Sales Chart the sales quantities are calculated over the same time period as displayed in the Inventory Chart.
The sales values include sales that are included in statements that have not been posted. All chart properties are the same for the Item Sales Chart and the Inventory Chart. That is, the functions for Period Length and Refresh work the same. Week is the default Period Length value, and the first column does not necessarily represent a whole week.
Selecting a Worksheet Template
To begin with, you need to select a worksheet to work with via the Name lookup.
On lookup the Lifecycle Worksheets page opens.
If there is only one worksheet available it is loaded upon opening the page. Each worksheet needs to have a season assigned to it. All totals in the Lifecycle Planning Worksheet are calculated with regard to the Starting Date and Ending Date of the associated season. Worksheets are also created and modified via the Lifecycle Worksheets page.
Linking Lifecycle Planning Worksheet to Redistribution Replenishment Journal
From the Lifecycle Worksheets page, you can assign the Replenishment Template Code to link a Lifecycle Planning Worksheet to a Redistribution Replenishment Journal in order to redistribute the broken sizes and colors among the stores.
The items to be calculated in the Redistribution Replenishment Journal will be taken from the Linked Lifecycle Planning Worksheet. You can use the Retail Item Variant Availability by Location page, which can be accessed from the Redistribution Replenishment Journal, to visualize the items or variant availability and use the page to facilitate variant redistribution among stores to fill the gaps.
If a Redistribution Replenishment Journal is linked to a Lifecycle Planning Worksheet, you can click the Open Journal action in Lifecycle Planning Worksheet to open the Redistribution Replenishment Journal.
Note: The Open Journal action in Lifecycle Planning Worksheet is only visible when there is a Redistribution Replenishment Journal linked to a Lifecycle Planning Worksheet.
Filtering on a Store
If you have a store assigned in Retail Users, the store filtering is done with regard to that store and the Store lookup is hidden on the Lifecycle Planning Worksheet.
If you do not have an assigned store in Retail Users, you can filter on Store via the Store lookup. All calculations are then done with regard to the selected store filtering.
Populating the Worksheet
The Process action group has actions that relate to populating the worksheet.
The action Get Items populates the Lifecycle Planning Worksheet with items that belong to the season associated with the selected worksheet:
When you press this action, a filtering dialog window is displayed:
In this window, filtering on Season Code has been selected, there is also filtering on Store and Location if a store has been selected in the worksheet. If you do not enter a filtering, a line in the worksheet is created for each item that has the selected Season Code. If you add other filters, the lines generated in the worksheet will reflect that.
If an item is added to the season later on, the action Get Items will update previous lines and create a line for the new item.
You can delete all lines in the worksheet by clicking the action Clear Worksheet.
To update the worksheet lines, you can click the Update Lines action. This action updates all fields in the worksheet lines, and the FactBox values are updated as well.
See Also